Close message Scootle is currently experiencing a technical issue which may affect logging in for some users. Scootle resources can still be accessed via Guest login. For any questions, please contact [email protected]

Digital technologies / Year 9 and 10 / Digital Technologies Processes and Production Skills

Version 8
Switch to version 9
View on Australian Curriculum website Australian Curriculum, Assessment and Reporting Authority
Curriculum content descriptions

Analyse and visualise data to create information and address complex problems, and model processes, entities and their relationships using structured data (ACTDIP037)

Elaborations
  • using visualisation software tools to identify patterns and relationships between sets of data and information, and support abstract reasoning, for example representing data using histograms, network diagrams and maps
  • summarising data using advanced filtering and grouping techniques, for example pivot tables in spreadsheets and aggregation functions in databases
  • automating calculations, for example using absolute cell referencing to automatically extend formulas, and automating arithmetic calculations using built-in functions such as trigonometry, compound interest
  • simulating simple, iterative processes, for example modelling compound interest or ecological models using a spreadsheet
  • documenting the attributes of complex objects and processes using a data dictionary
  • interpreting schemas that represent relationships between entities and querying data across tables, for example using foreign keys to represent relationships and joining tables in structured query language (SQL) SELECT statements
General capabilities
  • Literacy Literacy
  • Numeracy Numeracy
  • Critical and creative thinking Critical and creative thinking
  • ICT capability Information and Communication Technology (ICT) capability
ScOT terms

Data representation,  Data analysis,  Problem solving,  Information management,  Data storage

Refine by resource type

Refine by year level


Refine by learning area


Refine by topic

Related topic
  • No suggestions

11 direct matches to ACTDIP037

Online

Book analysis with AI techniques

  • TLF-IDA003333

This learning sequence explores text analysis through Natural Language Processing, a significant application of Artificial Intelligence. Teachers and students are led through a series of video tutorials to develop a Python program that can break down and analyse the content of a complete text and use smart sentiment analysis ...

View detailsView resource
Online

Seeing the wood for the trees

  • TLF-IDA003375

In this lesson sequence students summarise data using advanced filtering and grouping techniques, for example pivot tables in spreadsheets and aggregation functions in databases.

View detailsView resource
Online

A spreadsheet's secret weapon

  • TLF-IDA003391

In this lesson sequence, students learn to use pivot tables which have been described as the most powerful tool within spreadsheets.

View detailsView resource
Online

Spreadsheets come alive

  • TLF-IDA003394

In this lesson sequence use the ‘Odds and evens’ problem as a springboard. Students construct interactive spreadsheets designed to address particular needs. This lesson also demonstrates an approach to programming known as rapid application development (RAD).

View detailsView resource
Online

Data driven innovation

  • TLF-IDM021751

This is a unit for Year 9 from the Scope and sequence resources from the DT Hub. The topic of data is organised into four key elements. Use this flow of activities to plan and assess students against the relevant achievement standards. Students examine ways data from individuals and connected technologies is used to inform ...

View detailsView resource
Online

Organise, visualise and analyse

  • TLF-IDM021752

This is a unit for Year 10 from the Scope and sequence resources from the DT Hub. The topic of data is organised into four key elements. Use this flow of activities to plan and assess students against the relevant achievement standards. Students use tools to organise data and make sense of complex data to identify patterns ...

View detailsView resource
Text

Visualising climate change lesson

  • TLF-IDA002740

In this lesson, students explore different approaches to data representation, with the aim of engaging audiences with scientific data. They explore local temperature and rainfall datasets over time and represent trends in innovative ways. Students learn about different ways to visually represent climate change, looking ...

View detailsView resource
Online

Coding a sentimental chatbot in Python

  • TLF-IDA003335

Incorporating 11 tutorial videos and two informative lecture videos, this learning sequence explores natural language processing, a significant application of artificial intelligence. Teachers and students are led through the coding in Python of a chatbot, a conversational program capable of responding in varied ways to ...

View detailsView resource
Online

COVID 19 Demystified course

  • TLF-IDA003419

At the end of this course, learners should be able to better understand the science and numbers behindCOVID-19 and the SARS-CoV-2 virus that causes it. They should be able to discuss the pandemic with confidence, giving substantiated viewpoints on matters such as public policy with a willingness to accept other viewpoints. ...

View detailsView resource
Online

Filter bubbles, bias, rabbit holes and nudging

  • TLF-IDA003440

This lesson focuses on the AI systems that recommend content in various applications that students use on a day-to-day basis. It draws on students’ ethical understandings during analysis of these systems. This lesson was developed by the Digital Technologies Institute in collaboration with the Digital Technologies Hub.

View detailsView resource
Online

Who wants to be a millionaire?

  • TLF-IDA003416

This lesson sequence uses the well-known wheat/rice and chessboard problem as students use spreadsheets to simulate iteration and to solve problems.

View detailsView resource